Social Network Analysis - Amber Heard Case - YouTube

MAHMOUD NAGY - JAN 2022

Table of Contents

Introduction

YouTube - Social Network Analysis on Amber Heard's Case

https://stackoverflow.com/questions/24719368/syntaxerror-non-default-argument-follows-default-argument/39942121

Column Definition
etag Record (entity tag); Unique for each record
tl_etag Top Level Comment eTag
tl_id Top Level Comment ID
tl_video_id Top Level Comment Video ID
tl_text Top Level Comment Text
tl_author_display_name Top Level Comment Display name Not Unique
tl_author_channed_id Top Level Comment Channel ID Unique for each Author
tl_n_likes Top Level Comment Number of Likes
tl_comment_puplish_dtime Top Level Comment Number Publish Date Time
tl_comment_update_time Top Level Comment Number Update Date Time
n_replies Number of Replies of each record
replies.comments UNDER INVESTIGATIONS
tl_moderation_status Top Level Comment Moderation Status (Classified Spam or Not)

Exploratory Data Analysis





Exploring Likely Spam Comments

Note: These Comments are classified as likelySpam in youtube moderation_status


Primary Text Investigation

This positive comments section is to be deducted later from the negative comments data to increase the counts accuracy


Exploring Threat Comments

Filter on threat and hate speech keywords


A Heat Map for the Threat Comments

Threat Comments Peak Dates


Exploring Negative Comments

Negative Comments

Negative Comments

Likely-Spam Negative Comments

Negative Likely-Spam Comments Peak Dates

A Heat Map for the Negative Comments

Negative Comments Peak Dates


Contains "Victim"

A Heat Map for the Comments Containing "Victim"

Top Users with Comments Containing "victim" keyword

"victim" Users Contributions on Each Date

"victim" Peak Dates


More Investigations on Top Users Commented with "victim" Keyword


Negative Comments Without "Victim"


Most Repeated Comments

Same Text Same Date

Primary Text Investigation

In This Section:

Contains Amber

Contains Johnny

Contains F*ck

Contains B*tch

Contains Abuser

Contains Liar

Contains Crazy

Contains Disgusting

Contains Jail


Conclusions

END OF NOTEBOOK